SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_SearchAvailableField]
    (
      @JOL_Field_Name VARCHAR(50)
    )
AS 
    SELECT  JOL_Field_No,
            JOL_Field_Name,
            JOL_Field_Campus,
            JOL_Field_SeatNumber,
            JOL_Field_Money,
            JOL_Field_IsProvideMultimedia
    FROM    dbo.JOL_AvailableField
    WHERE   JOL_Field_Name LIKE '%' + @JOL_Field_Name + '%'
    ORDER BY JOL_Field_AddTime DESC,
            JOL_Field_UpdateTime DESC

GO
